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 706: p_date_earned in pay_payroll_actions.date_earned%TYPE

702:
703: function check_if_retro
704: (
705: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
706: p_date_earned in pay_payroll_actions.date_earned%TYPE
707: ) return varchar2 IS
708:
709: cursor c_get_creator_type(
710: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

Line 711: c_date_earned in pay_payroll_actions.date_earned%TYPE

707: ) return varchar2 IS
708:
709: cursor c_get_creator_type(
710: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
711: c_date_earned in pay_payroll_actions.date_earned%TYPE
712: ) is
713: SELECT creator_type
714: FROM pay_element_entries_f pee
715: WHERE pee.element_entry_id = c_element_entry_id

Line 761: p_date_earned in pay_payroll_actions.date_earned%TYPE,

757:
758: function which_retro_method
759: (
760: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
761: p_date_earned in pay_payroll_actions.date_earned%TYPE,
762: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
763: ) return varchar2 IS
764:
765: /*

Line 772: c_date_earned in pay_payroll_actions.date_earned%TYPE,

768: */
769:
770: cursor get_retro_method
771: ( c_assignment_id in pay_element_entries_f.element_entry_id%TYPE,
772: c_date_earned in pay_payroll_actions.date_earned%TYPE,
773: c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE
774: ) is
775: select pet.element_name
776: from pay_element_entries_f pee,

Line 778: pay_payroll_actions ppa,

774: ) is
775: select pet.element_name
776: from pay_element_entries_f pee,
777: pay_assignment_actions paa,
778: pay_payroll_actions ppa,
779: pay_element_sets pes,
780: pay_element_type_rules petr,
781: pay_element_types_f pet
782: where pee.creator_id = paa.assignment_action_id

Line 799: pay_payroll_actions ppa,

795: union all
796: select pec.classification_name
797: from pay_element_entries_f pee,
798: pay_assignment_actions paa,
799: pay_payroll_actions ppa,
800: pay_element_sets pes,
801: pay_ele_classification_rules pecr,
802: pay_element_classifications pec
803: where pee.creator_id = paa.assignment_action_id

Line 908: p_date_earned in pay_payroll_actions.date_earned%TYPE

904: ---------------------------------------------------------------------------
905: function get_prev_year_ord_ytd
906: (
907: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
908: p_date_earned in pay_payroll_actions.date_earned%TYPE
909: )
910: return number is
911: --
912: cursor c_tax_unit_id( c_assignment_id number,

Line 933: pay_payroll_actions ppa

929: to_number(to_char(ppa.effective_date,'MM')),
930: max(pas.person_id)
931: from per_assignments_f pas,
932: pay_assignment_actions paa,
933: pay_payroll_actions ppa
934: where (pas.person_id, paa.tax_unit_id)
935: IN (select pas1.person_id,
936: hsc1.segment1
937: from per_assignments_f pas1,

Line 959: pay_payroll_actions ppa

955: ppa.effective_date,
956: paa.assignment_id
957: from per_assignments_f pas,
958: pay_assignment_actions paa,
959: pay_payroll_actions ppa
960: where pas.person_id = c_person_id /* Bug 5298298 */
961: and paa.assignment_id = pas.assignment_id
962: and ppa.payroll_action_id = paa.payroll_action_id
963: and paa.action_sequence = c_action_sequence

Line 1093: p_date_earned in pay_payroll_actions.date_earned%TYPE

1089: ---------------------------------------------------------------------------
1090: function get_cur_year_ord_ytd
1091: (
1092: p_assignment_id in pay_assignment_actions.assignment_id%TYPE,
1093: p_date_earned in pay_payroll_actions.date_earned%TYPE
1094: )
1095: return number is
1096: --
1097: cursor c_tax_unit_id( c_assignment_id number,

Line 1118: pay_payroll_actions ppa

1114: to_number(to_char(ppa.effective_date,'MM')),
1115: max(pas.person_id)
1116: from per_assignments_f pas,
1117: pay_assignment_actions paa,
1118: pay_payroll_actions ppa
1119: where (pas.person_id, paa.tax_unit_id)
1120: IN (select pas1.person_id,
1121: hsc1.segment1
1122: from per_assignments_f pas1,

Line 1144: pay_payroll_actions ppa

1140: ppa.effective_date,
1141: pas.assignment_id
1142: from per_assignments_f pas,
1143: pay_assignment_actions paa,
1144: pay_payroll_actions ppa
1145: where pas.person_id = c_person_id /* Bug 5298298 */
1146: and paa.assignment_id = pas.assignment_id
1147: and ppa.payroll_action_id = paa.payroll_action_id
1148: and paa.action_sequence = c_action_sequence

Line 1285: pay_payroll_actions ppa1

1281: where pee.assignment_id = p_assignment_id
1282: and pee.source_asg_action_id in
1283: (select paa1.assignment_action_id
1284: from pay_assignment_actions paa1,
1285: pay_payroll_actions ppa1
1286: where paa1.assignment_id = pee.assignment_id
1287: and ppa1.payroll_action_id = paa1.payroll_action_id
1288: and ppa1.action_type in ('R','Q','B','V','I')
1289: and to_char(ppa1.effective_date,'MM') = to_char(p_date_earned,'MM'))