APPS.PAY_FI_ARCHIVE_PSTA dependencies on PER_TIME_PERIODS

Line 37: g_period_type per_time_periods.period_type%type;

33: g_pay_period varchar2 (240);
34: g_payroll varchar2 (240);
35: g_pay_period_end_date date;
36: g_pay_period_start_date date;
37: g_period_type per_time_periods.period_type%type;
38: g_time_period_id per_time_periods.time_period_id%type;
39: g_legal_employer_name varchar2 (240);
40: g_person_id number := -1;
41: g_arch_payroll_action_id number;

Line 38: g_time_period_id per_time_periods.time_period_id%type;

34: g_payroll varchar2 (240);
35: g_pay_period_end_date date;
36: g_pay_period_start_date date;
37: g_period_type per_time_periods.period_type%type;
38: g_time_period_id per_time_periods.time_period_id%type;
39: g_legal_employer_name varchar2 (240);
40: g_person_id number := -1;
41: g_arch_payroll_action_id number;
42: g_payroll_type varchar2 (200);

Line 413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf

409: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%type
410: ) is
411: select papf.payroll_id, papf.payroll_name, ptp.start_date, ptp.end_date, ptp.period_name, ptp.period_type,
412: ptp.regular_payment_date, ptp.time_period_id
413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf
414: where ptp.time_period_id = ppa.time_period_id
415: and ppa.payroll_id = papf.payroll_id
416: and ppa.payroll_action_id = csr_v_payroll_action_id;
417:

Line 425: time_period_id per_time_periods.time_period_id%type,

421:
422:
423: /* PL/SQL table to take the period and assignment action details for the benefits */
424: type time_period_detail_rec is record (
425: time_period_id per_time_periods.time_period_id%type,
426: pay_period_start_date per_time_periods.start_date%type,
427: pay_period_end_date per_time_periods.end_date%type,
428: pay_period per_time_periods.period_name%type,
429: assignment_action_id number

Line 426: pay_period_start_date per_time_periods.start_date%type,

422:
423: /* PL/SQL table to take the period and assignment action details for the benefits */
424: type time_period_detail_rec is record (
425: time_period_id per_time_periods.time_period_id%type,
426: pay_period_start_date per_time_periods.start_date%type,
427: pay_period_end_date per_time_periods.end_date%type,
428: pay_period per_time_periods.period_name%type,
429: assignment_action_id number
430: );

Line 427: pay_period_end_date per_time_periods.end_date%type,

423: /* PL/SQL table to take the period and assignment action details for the benefits */
424: type time_period_detail_rec is record (
425: time_period_id per_time_periods.time_period_id%type,
426: pay_period_start_date per_time_periods.start_date%type,
427: pay_period_end_date per_time_periods.end_date%type,
428: pay_period per_time_periods.period_name%type,
429: assignment_action_id number
430: );
431:

Line 428: pay_period per_time_periods.period_name%type,

424: type time_period_detail_rec is record (
425: time_period_id per_time_periods.time_period_id%type,
426: pay_period_start_date per_time_periods.start_date%type,
427: pay_period_end_date per_time_periods.end_date%type,
428: pay_period per_time_periods.period_name%type,
429: assignment_action_id number
430: );
431:
432: type benefit_time_period is table of time_period_detail_rec

Line 484: pay_period_start_date per_time_periods.start_date%type,

480: l_monetary_value number := 0;
481:
482: /* PL/SQL table to take the Benefit details for final archiving the data */
483: type benefit_archive_details_rec is record (
484: pay_period_start_date per_time_periods.start_date%type,
485: pay_period_end_date per_time_periods.end_date%type,
486: pay_current_end_date per_time_periods.end_date%type,
487: benefit_name varchar2 (240),
488: benfit_value number,

Line 485: pay_period_end_date per_time_periods.end_date%type,

481:
482: /* PL/SQL table to take the Benefit details for final archiving the data */
483: type benefit_archive_details_rec is record (
484: pay_period_start_date per_time_periods.start_date%type,
485: pay_period_end_date per_time_periods.end_date%type,
486: pay_current_end_date per_time_periods.end_date%type,
487: benefit_name varchar2 (240),
488: benfit_value number,
489: assignment_id number,

Line 486: pay_current_end_date per_time_periods.end_date%type,

482: /* PL/SQL table to take the Benefit details for final archiving the data */
483: type benefit_archive_details_rec is record (
484: pay_period_start_date per_time_periods.start_date%type,
485: pay_period_end_date per_time_periods.end_date%type,
486: pay_current_end_date per_time_periods.end_date%type,
487: benefit_name varchar2 (240),
488: benfit_value number,
489: assignment_id number,
490: person_id number,