APPS.PER_NL_FDR_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 17: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

13: ,p_token in varchar2
14: ,p_segment_number in number default null ) RETURN varchar2
15: IS
16:
17: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
18: l_start_pos NUMBER;
19: l_delimiter varchar2(1):=' ';
20:
21: BEGIN

Line 76: FROM pay_payroll_actions

72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))
73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))
74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))
75: ,business_group_id
76: FROM pay_payroll_actions
77: WHERE payroll_action_id = p_payroll_action_id;
78:
79: --
80: l_parameter_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;

Line 80: l_parameter_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;

76: FROM pay_payroll_actions
77: WHERE payroll_action_id = p_payroll_action_id;
78:
79: --
80: l_parameter_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;
81:
82: BEGIN
83:
84: --hr_utility.set_location('Entering get_all_parameters',51);

Line 95: from pay_payroll_actions ppa

91: ,p_bg_id;
92: CLOSE csr_parameter_info;
93:
94: select ppa.legislative_parameters into l_parameter_string
95: from pay_payroll_actions ppa
96: where ppa.payroll_action_id = p_payroll_action_id;
97:
98:
99: IF instr(l_parameter_string,'/',1,2) - instr(l_parameter_string,'/',1,1) = 3 THEN

Line 632: ,pay_payroll_actions ppa

628:
629:
630: sqlstr := 'SELECT DISTINCT person_id
631: FROM per_all_people_f pap
632: ,pay_payroll_actions ppa
633: WHERE ppa.payroll_action_id = :payroll_action_id
634: AND ppa.business_group_id = pap.business_group_id
635: ORDER BY pap.person_id';
636:

Line 676: pay_payroll_actions ppa,

672: select distinct paa.assignment_id assignment_id
673:
674: from per_all_assignments_f paa,
675: per_assignment_status_types past,
676: pay_payroll_actions ppa,
677: per_all_people_f pap,
678: per_periods_of_service ppos
679:
680: where p_person_id between p_start_person_id and p_end_person_id

Line 721: pay_payroll_actions ppa,

717:
718: from per_all_assignments_f paa,
719: per_assignment_status_types past,
720: per_all_people_f pap,
721: pay_payroll_actions ppa,
722: per_periods_of_service ppos,
723: per_org_structure_versions posv
724:
725: where posv.organization_structure_id=p_org_struct_id

Line 778: pay_payroll_actions ppa,

774:
775: from per_all_assignments_f paa,
776: per_assignment_status_types past,
777: per_all_people_f pap,
778: pay_payroll_actions ppa,
779: per_periods_of_service ppos,
780: per_org_structure_versions posv
781:
782: where posv.organization_structure_id=p_org_struct_id

Line 1046: l_parameter_string pay_payroll_actions.legislative_parameters%type;

1042: l_xfdf_clob CLOB;
1043: l_action_info_id NUMBER;
1044: l_ovn NUMBER;
1045: l_create_peit VARCHAR2(1);
1046: l_parameter_string pay_payroll_actions.legislative_parameters%type;
1047:
1048:
1049:
1050: BEGIN

Line 1058: FROM pay_payroll_actions ppa,

1054: l_create_peit := 'Y';
1055:
1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')
1057: INTO l_report_date
1058: FROM pay_payroll_actions ppa,
1059: pay_assignment_actions paa
1060: WHERE paa.payroll_action_id = ppa.payroll_action_id
1061: AND paa.assignment_action_id = p_assignment_action_id;
1062:

Line 1065: FROM pay_payroll_actions ppa,

1061: AND paa.assignment_action_id = p_assignment_action_id;
1062:
1063: SELECT ppa.legislative_parameters
1064: INTO l_parameter_string
1065: FROM pay_payroll_actions ppa,
1066: pay_assignment_actions paa
1067: WHERE paa.payroll_action_id = ppa.payroll_action_id
1068: AND paa.assignment_action_id = p_assignment_action_id;
1069:

Line 1078: FROM pay_payroll_actions ppa,

1074: g_year := to_char(to_date(l_report_date,'RRRR/MM/DD'),'RRRR');
1075:
1076: select TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'ORG_STRUCT_ID'))
1077: INTO l_org_struct_id
1078: FROM pay_payroll_actions ppa,
1079: pay_assignment_actions paa
1080: WHERE paa.payroll_action_id = ppa.payroll_action_id
1081: AND paa.assignment_action_id = p_assignment_action_id;
1082:

Line 1313: pay_payroll_actions ppa,

1309:
1310: from per_all_assignments_f paa,
1311: per_assignment_status_types past,
1312: per_all_people_f pap,
1313: pay_payroll_actions ppa,
1314: per_periods_of_service ppos,
1315: per_org_structure_versions posv
1316:
1317: where posv.organization_structure_id=p_org_struct_id