APPS.PAY_NL_CBS_FILE dependencies on PAY_PAYROLL_ACTIONS

Line 48: FROM pay_payroll_actions

44: ,pay_core_utils.get_parameter('MEDIUM_CODE',legislative_parameters)
45: ,pay_core_utils.get_parameter('DENSITY',legislative_parameters)
46: ,effective_date
47: ,business_group_id
48: FROM pay_payroll_actions
49: WHERE payroll_action_id = p_payroll_action_id;
50: --
51: -- l_effective_date date;
52: -- l_proc VARCHAR2(80):= g_package||' get_all_parameters ';

Line 882: from pay_payroll_actions ppa,pay_assignment_Actions paa

878: RETURN NUMBER IS
879:
880: cursor csr_get_date_earned(p_asg_act_id number) is
881: select date_earned
882: from pay_payroll_actions ppa,pay_assignment_Actions paa
883: where
884: ppa.payroll_action_id = paa.payroll_action_id
885: and paa.assignment_action_id = p_max_assgt_act_id;
886:

Line 952: l_report_type pay_payroll_actions.report_type%TYPE;

948: l_business_group_id NUMBER;
949: l_employer_id NUMBER;
950: l_si_provider_id NUMBER;
951: l_payroll_id NUMBER;
952: l_report_type pay_payroll_actions.report_type%TYPE;
953: l_effective_date DATE;
954: l_employer NUMBER;
955: l_si_provider NUMBER;
956: l_org_struct_id NUMBER;

Line 1156: ,pay_payroll_actions ppa

1152: -- hr_utility.set_location('Generating the query for assignment actiond ids',600);
1153:
1154: sqlstr := 'SELECT DISTINCT person_id
1155: FROM per_people_f ppf
1156: ,pay_payroll_actions ppa
1157: WHERE ppa.payroll_action_id = :payroll_action_id
1158: AND ppa.business_group_id = ppf.business_group_id
1159: ORDER BY ppf.person_id';
1160:

Line 1180: ,pay_payroll_actions ppa

1176: ELSE
1177: /*If mandatory data is missing do not return any person ids*/
1178: sqlstr := 'SELECT DISTINCT person_id
1179: FROM per_people_f ppf
1180: ,pay_payroll_actions ppa
1181: WHERE ppa.payroll_action_id = :payroll_action_id
1182: AND 1 = 2
1183: AND ppa.business_group_id = ppf.business_group_id
1184: ORDER BY ppf.person_id';

Line 1348: l_report_type pay_payroll_actions.report_type%TYPE;

1344: l_business_group_id NUMBER;
1345: l_employer_id NUMBER;
1346: l_si_provider_id NUMBER;
1347: l_payroll_id NUMBER;
1348: l_report_type pay_payroll_actions.report_type%TYPE;
1349: l_effective_date DATE;
1350: l_employer NUMBER;
1351: l_si_provider NUMBER;
1352: l_org_struct_id NUMBER;