eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 883: p_date_earned in pay_payroll_actions.date_earned%TYPE

879:
880: function check_if_retro
881: (
882: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
883: p_date_earned in pay_payroll_actions.date_earned%TYPE
884: ) return varchar2 IS
885:
886: cursor c_get_creator_type(
887: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

Line 888: c_date_earned in pay_payroll_actions.date_earned%TYPE

884: ) return varchar2 IS
885:
886: cursor c_get_creator_type(
887: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
888: c_date_earned in pay_payroll_actions.date_earned%TYPE
889: ) is
890: SELECT creator_type
891: FROM pay_element_entries_f pee
892: WHERE pee.element_entry_id = c_element_entry_id

Line 938: p_date_earned in pay_payroll_actions.date_earned%TYPE,

934:
935: function which_retro_method
936: (
937: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
938: p_date_earned in pay_payroll_actions.date_earned%TYPE,
939: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
940: ) return varchar2 IS
941:
942: /*

Line 949: c_date_earned in pay_payroll_actions.date_earned%TYPE,

945: */
946:
947: cursor get_retro_method
948: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
949: c_date_earned in pay_payroll_actions.date_earned%TYPE,
950: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
951: ) is
952: select pet.element_name
953: from pay_element_entries_f pee,

Line 955: pay_payroll_actions ppa,

951: ) is
952: select pet.element_name
953: from pay_element_entries_f pee,
954: pay_assignment_actions paa,
955: pay_payroll_actions ppa,
956: pay_element_sets pes,
957: pay_element_type_rules petr,
958: pay_element_types_f pet
959: where pee.creator_id = paa.assignment_action_id

Line 976: pay_payroll_actions ppa,

972: union all
973: select pec.classification_name
974: from pay_element_entries_f pee,
975: pay_assignment_actions paa,
976: pay_payroll_actions ppa,
977: pay_element_sets pes,
978: pay_ele_classification_rules pecr,
979: pay_element_classifications pec
980: where pee.creator_id = paa.assignment_action_id

Line 1085: p_date_earned in pay_payroll_actions.date_earned%TYPE

1081: ---------------------------------------------------------------------------
1082: function get_prev_year_ord_ytd
1083: (
1084: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1085: p_date_earned in pay_payroll_actions.date_earned%TYPE
1086: )
1087: return number is
1088: --
1089: cursor c_tax_unit_id( c_assignment_id number,

Line 1110: pay_payroll_actions ppa

1106: to_number(to_char(ppa.effective_date,'MM')),
1107: max(pas.person_id)
1108: from per_assignments_f pas,
1109: pay_assignment_actions paa,
1110: pay_payroll_actions ppa
1111: where (pas.person_id, paa.tax_unit_id)
1112: IN (select pas1.person_id,
1113: hsc1.segment1
1114: from per_assignments_f pas1,

Line 1136: pay_payroll_actions ppa

1132: ppa.effective_date,
1133: paa.assignment_id
1134: from per_assignments_f pas,
1135: pay_assignment_actions paa,
1136: pay_payroll_actions ppa
1137: where pas.person_id = c_person_id /* Bug 5298298 */
1138: and paa.assignment_id = pas.assignment_id
1139: and ppa.payroll_action_id = paa.payroll_action_id
1140: and paa.action_sequence = c_action_sequence

Line 1295: p_date_earned in pay_payroll_actions.date_earned%TYPE

1291: ---------------------------------------------------------------------------
1292: function get_cur_year_ord_ytd
1293: (
1294: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1295: p_date_earned in pay_payroll_actions.date_earned%TYPE
1296: )
1297: return number is
1298: --
1299: cursor c_tax_unit_id( c_assignment_id number,

Line 1320: pay_payroll_actions ppa

1316: to_number(to_char(ppa.effective_date,'MM')),
1317: max(pas.person_id)
1318: from per_assignments_f pas,
1319: pay_assignment_actions paa,
1320: pay_payroll_actions ppa
1321: where (pas.person_id, paa.tax_unit_id)
1322: IN (select pas1.person_id,
1323: hsc1.segment1
1324: from per_assignments_f pas1,

Line 1346: pay_payroll_actions ppa

1342: ppa.effective_date,
1343: pas.assignment_id
1344: from per_assignments_f pas,
1345: pay_assignment_actions paa,
1346: pay_payroll_actions ppa
1347: where pas.person_id = c_person_id /* Bug 5298298 */
1348: and paa.assignment_id = pas.assignment_id
1349: and ppa.payroll_action_id = paa.payroll_action_id
1350: and paa.action_sequence = c_action_sequence

Line 1512: pay_payroll_actions ppa1

1508: where pee.assignment_id = p_assignment_id
1509: and pee.source_asg_action_id in
1510: (select paa1.assignment_action_id
1511: from pay_assignment_actions paa1,
1512: pay_payroll_actions ppa1
1513: where paa1.assignment_id = pee.assignment_id
1514: and ppa1.payroll_action_id = paa1.payroll_action_id
1515: and ppa1.action_type in ('R','Q','B','V','I')
1516: and to_char(ppa1.effective_date,'MM') = to_char(p_date_earned,'MM'))