APPS.PQP_TIAALOD_PKG dependencies on PAY_PAYROLLS_F

Line 35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;

31: l_first_name per_all_people_f.first_name%TYPE;
32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;
36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;
37: l_payroll_id per_assignments_f.payroll_id%TYPE;
38: l_org_ppg hr_organization_information.org_information1%TYPE;
39: l_err_msg VARCHAR2(800);

Line 36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;

32: l_middle_name per_all_people_f.middle_names%TYPE;
33: l_dob per_all_people_f.date_of_birth%TYPE;
34: l_asg_ppg_code per_assignment_extra_info.aei_information1%TYPE;
35: l_pay_mode pay_payrolls_f.prl_information4%TYPE;
36: l_ppg_billing pay_payrolls_f.prl_information7%TYPE;
37: l_payroll_id per_assignments_f.payroll_id%TYPE;
38: l_org_ppg hr_organization_information.org_information1%TYPE;
39: l_err_msg VARCHAR2(800);
40: l_err_num VARCHAR2(800);

Line 46: payment_mode pay_payrolls_f.prl_information4%TYPE,

42: l_ld_payroll_id pay_payroll_actions.payroll_id%TYPE;
43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;
44:
45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,
46: payment_mode pay_payrolls_f.prl_information4%TYPE,
47: ppg_billing_code pay_payrolls_f.prl_information7%TYPE,
48: effective_date date);
49:
50: TYPE t_pay_mode IS TABLE OF r_pay_mode INDEX BY BINARY_INTEGER;

Line 47: ppg_billing_code pay_payrolls_f.prl_information7%TYPE,

43: l_prev_payroll_id pay_payroll_actions.payroll_id%TYPE;
44:
45: TYPE r_pay_mode IS RECORD (payroll_id per_assignments_f.payroll_id%TYPE,
46: payment_mode pay_payrolls_f.prl_information4%TYPE,
47: ppg_billing_code pay_payrolls_f.prl_information7%TYPE,
48: effective_date date);
49:
50: TYPE t_pay_mode IS TABLE OF r_pay_mode INDEX BY BINARY_INTEGER;
51:

Line 68: pay_mode pay_payrolls_f.prl_information4%TYPE,

64: dob per_all_people_f.date_of_birth%TYPE,
65: national_id per_all_people_f.national_identifier%TYPE,
66: asg_ppg_code per_assignment_extra_info.aei_information1%TYPE,
67: org_ppg hr_organization_information.org_information1%TYPE,
68: pay_mode pay_payrolls_f.prl_information4%TYPE,
69: gre_name hr_organization_units.name%TYPE,
70: org_name hr_organization_units.name%TYPE,
71: effective_date DATE,
72: ppg_billing pay_payrolls_f.prl_information7%TYPE,

Line 72: ppg_billing pay_payrolls_f.prl_information7%TYPE,

68: pay_mode pay_payrolls_f.prl_information4%TYPE,
69: gre_name hr_organization_units.name%TYPE,
70: org_name hr_organization_units.name%TYPE,
71: effective_date DATE,
72: ppg_billing pay_payrolls_f.prl_information7%TYPE,
73:
74: balance_name1 pay_balance_types.balance_name%TYPE,
75: balance_value1 NUMBER,
76: balance_name2 pay_balance_types.balance_name%TYPE,

Line 533: FROM pay_payrolls_f prl

529: PROCEDURE ppg_billing(p_payroll_id IN NUMBER) IS
530:
531: CURSOR c_ppg_billing IS
532: SELECT prl.prl_information7
533: FROM pay_payrolls_f prl
534: WHERE prl.payroll_id = p_payroll_id
535: AND prl.prl_information_category = 'US'
536: AND l_effective_date BETWEEN prl.effective_start_date
537: AND prl.effective_end_date;

Line 573: FROM pay_payrolls_f prl

569:
570: CURSOR c_pay_mode IS
571: SELECT prl.prl_information4
572: ,prl.prl_information7
573: FROM pay_payrolls_f prl
574: WHERE prl.payroll_id = p_payroll_id
575: AND prl.prl_information_category = 'US'
576: AND l_effective_date BETWEEN prl.effective_start_date
577: AND prl.effective_end_date;